<?php
session_start();
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Schools Management System</title>
<meta http-equiv="Content-Language" content="English" />
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<link rel="stylesheet" type="text/css" href="../style.css" media="screen" />

</head>
<body>

<div id="wrap">

<div id="header"><table width="1239" border="0">
  <tr>
    <td width="866" height="119" rowspan="2"><h1 class="heaaderte"><font color="#996699" style="text-shadow:#969" size="+6">Schools Management System</font></h1></td>
    <td width="110" height="88">&nbsp;</td>
    <td width="161">&nbsp;</td>
    <td width="84">&nbsp;</td>
  </tr>
  <tr>
    <td height="21">&nbsp;</td>
    <td>
	<?Php
	//$First_Name=$_SESSION['First_Name'];
    //$_SESSION['Last_Name']=$Last_Name;
	  if(isset($_SESSION['First_Name']))
	  
{
      echo "Hi,". $_SESSION['First_Name']." ".$_SESSION['Last_Name'];
}
?></td>
    <td><a href="../Logout.php" class="logout">Logout</a></td>
  </tr>
  </table>
</div>

<div id="menu1_bg">
		<div id="menu1">
				<ul>
				<li><a href="../index.php"><font color="#CCCC66" style="text-shadow:#969" size="+1">Home</font></a></li>
				<li><a href="../Schools/Schools.php"><font color="#CCCC66" style="text-shadow:#969" size="+1">Schools</font></a></li>
				<li><a href="../Teachers/teachers.php"><font color="#CCCC66" style="text-shadow:#969" size="+1">Teachers</font></a></li>
				<li><a href="Labs.php" class="active"><font color="#CCCC66" style="text-shadow:#969" size="+1">Labs</font></a></li>
				<li><a href="../Resources/Resources.php"><font color="#CCCC66" style="text-shadow:#969" size="+1">Resources</font></a></li>
                <li><a href="#"><font color="#CCCC66" style="text-shadow:#969" size="+1">Resource Team</font></a></li>
                         <li><a href="../Programmes/Programmes.php"><font color="#CCCC66" style="text-shadow:#969" size="+1">Programmes</font></a></li>
                                  <li><a href="../Competition/Competition.php""><font color="#CCCC66" style="text-shadow:#969" size="+1">Competitions</font></a></li>
                 <li></li>
			</ul>
	</div>
  </div>
<div class="left">
  
<div class="articles">
<?php
include_once '../Login/databaseconnection.php';
if(!loggedin())
{
require_once '../index.php';
}
   
   else
   {
   
$result=mysql_query("SELECT * FROM lab");


if(mysql_num_rows($result)!=0)
   {
   
echo '<div style="overflow:scroll;">';
echo '<table width="957" border="1">
<tr>
<td width="94">Lab_Id</td>
<td width="46">School Id</td>
<td width="130">Source Of Power</td>
<td width="100">Tp Number</td>
<td width="158">Account_Number</td>
<td width="137">Date of commencement</td>
<td width="93">Availability Of LAN</td>
<td width="159">LAN Supplier</td>
<td width="100">Supplied Date</td>
<td width="158">Speed_Of_WAN</td>
<td width="137">WAN Connection Type</td>
<td width="93">Internet_Facilities</td>
<td width="93">Wired Date</td>

</tr>';
  while($row=mysql_fetch_array($result))
  {
$Sch_Id=$row['School_Id'];
$Lab_Id=$row['Lab_Id'];
$resultnet=mysql_query("SELECT * FROM network WHERE Lab_Id='$Lab_Id' AND School_Id='$Sch_Id'");


  while($rownet=mysql_fetch_array($resultnet))
  {
 $Availability_Of_LAN=$rownet['Availability_Of_LAN'];
    $LAN_Supplier=$rownet['LAN_Supplier'];
	$Supplied_Date=$rownet['Supplied_Date'];
    $Speed_Of_WAN=$rownet['Speed_Of_WAN'];
    $WAN_Connection_Type=$rownet['WAN_Connection_Type'];
    $Internet_Facilities=$rownet['Internet_Facilities'];
	$Wired_Date=$rownet['Wired_Date'];
	}

	
  echo '<tr>';
    echo '<td width="94">'.$row['Lab_Id'].'</td>';
    echo '<td width="65">'.$row['School_Id'].'</td>';
    echo '<td width="130">'.$row['Source_Of_Power'].'</td>';
    echo '<td width="100">'.$row['Tp_Number'].'</td>';
    echo '<td width="158">'.$row['Account_Number'].'</td>';
    echo '<td width="137">'.$row['Date_of_commencement'].'</td>';
	if(mysql_num_rows($resultnet)!=0)
  {
    echo '<td width="93">'.$Availability_Of_LAN.'</td>';
    echo '<td width="159">'.$LAN_Supplier.'</td>';
	echo '<td width="158">'.$Supplied_Date.'</td>';
    echo '<td width="137">'.$Speed_Of_WAN.'</td>';
    echo '<td width="93">'.$WAN_Connection_Type.'</td>';
    echo '<td width="159">'.$Internet_Facilities.'</td>';
	echo '<td width="159">'.$Wired_Date.'</td>';
	}
	else
	{
	echo '<td width="93"></td>';
    echo '<td width="159"></td>';
	echo '<td width="158"></td>';
    echo '<td width="137"></td>';
    echo '<td width="93"></td>';
    echo '<td width="159"></td>';
	 echo '<td width="159"></td>';
	}
  echo '</tr>';
  }
   echo "</table>";
   echo '</div>';
  }
  }
  ?>
  </div>
</div>

<div class="rightmenu"> 
<h1>LABS</h1><br />
<table width="220" border="0">
  <tr>
    <td width="210" height="41"><a href="RegLab.php">Add New Lab</a></td>
   

  </tr>
  <tr>
    <td height="41"><a href="SearchLab.php">Search a Lab</a></td>
    
    
  </tr>
  <tr>
    <td height="41"><a href="SearchLabSch.php">Search Labs for a school</a></td>

    
  </tr>
  <tr>
    <td height="41"><a href="UpdateLab.php">Update a  Lab of a School</a></td>
 
    
  </tr>
  <tr>
    <td height="41"><a href="DelLab.php">Delete a  Lab of a School</a></td>
    
    
  </tr>
  <tr>
    <td height="41"><a href="viewall.php">View All</a></td>
   

  </tr>
</table></div>

 
 <div style="clear: both;"> </div>


<div id="footer"><table width="1236" height="38" border="0">
    <tr>
      <td width="904" height="34">Schools Managemrnt System &copy; 2012 </td>
      <td width="50"><strong><a href="#" class="active">Home</a><a href="#"></a></strong>|</td>
      <td width="80"><strong><a href="#">Contact us</a></strong>|</td>
      <td width="40"><a href="http//www.facebook.com"><img src="../images/facebook1.png" width="38" height="38"/></a></td>
      <td width="38"><a href="http//twitter.com"><img src="../Images/twitter.png" width="38" height="38"/></a></td>
      <td width="36"><a href="http//www.google.lk"><img src="../Images/google.png" width="38" height="38"/></a><a href=""http="http"//www.yahoo.com""></a></td>
      <td width="58"><a href=""http="http"//www.yahoo.com""><img src="../Images/yahoo.png" alt="" width="38" height="38"/></a></td>
    </tr>
  </table>
</div>
</div>

</body>
</html>